﻿CREATE TABLE [dbo].[NormControlDocs] (
    [NormControlDocId] UNIQUEIDENTIFIER NOT NULL,
    [IsPassed]         BIT              NOT NULL,
    [FileName]         NVARCHAR (MAX)   NOT NULL,
    [StudentId]        UNIQUEIDENTIFIER NOT NULL,
    [StudentNotes]     NVARCHAR (MAX)   NULL,
    [ControllerNotes]  NVARCHAR (MAX)   NULL,
    [DocFile]          VARBINARY (MAX)  NOT NULL,
    [PdfFile]          VARBINARY (MAX)  NOT NULL,
    [DateSanded]       DATETIME         NOT NULL
);



